create  table jms_dm.dm_network_bagging_user_cnt_dt
(    network_code  varchar(120) comment'编号'
    ,  virt_code     varchar(120) comment'虚拟代理区code'
    , virt_name     varchar(120) comment'虚拟代理区name'
    , agent_code    varchar(120) comment'代理区编码'
    , agent_name    varchar(120) comment'代理区名称'
    , fran_code     varchar(120) comment'加盟商编码'
    , fran_name     varchar(120) comment'加盟商名称'
    , provider_id   varchar(120) comment'省份ID'
    , provider_desc varchar(120) comment'省份'
    , city_id       varchar(120) comment'城市ID'
    , city_desc     varchar(120) comment'城市'
    , area_id       varchar(120) comment'区/县id'
    , area_desc     varchar(120) comment'区/县'
    , network_name  varchar(120) comment'名称'
    , bag_user_code varchar(120) comment'建包扫描人code'
    , bag_user_name varchar(120) comment'建包扫描人name'
    , bagging_qty      int comment'已建包票数'
    , package_qty      int comment'建包数(包号去重)'
    , net_bagging_qty  int comment'总网点票数'
    ,date_time date comment '日期'
)ENGINE=OLAP DUPLICATE KEY(network_code)
comment '建包扫描人效-老板你好，集包效能明细'
PARTITION BY RANGE (date_time) (
   START ("2023-03-02") END ("2023-05-01") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(network_code,area_id) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);